<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="zh-cn" xml:lang="zh-cn">
 <head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="DC.Type" content="topic">
  <meta name="DC.Title" content="查询ClickHouse信息">
  <meta name="product" content="">
  <meta name="DC.Relation" scheme="URI" content="clickhouse-0053.html">
  <meta name="prodname" content="">
  <meta name="version" content="">
  <meta name="brand" content="30-OceanProtect 备份一体机 1.5.0-1.6.0 帮助中心">
  <meta name="DC.Publisher" content="20240320">
  <meta name="prodname" content="csbs">
  <meta name="documenttype" content="usermanual">
  <meta name="DC.Format" content="XHTML">
  <meta name="DC.Identifier" content="clickhouse-0054">
  <meta name="DC.Language" content="zh-cn">
  <link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
  <title>查询ClickHouse信息</title>
 </head>
 <body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px">
  <a name="clickhouse-0054"></a><a name="clickhouse-0054"></a>
  <h1 class="topictitle1">查询ClickHouse信息</h1>
  <div>
   <div class="section">
    <h4 class="sectiontitle">操作步骤</h4>
    <ol>
     <li><span>选择<span class="uicontrol" id="clickhouse-0054__zh-cn_topic_0000001839142377_uicontrol12263171215409">“<span id="clickhouse-0054__zh-cn_topic_0000001839142377_text1926371213406">保护</span> &gt; 大数据 &gt; ClickHouse”</span>。</span></li>
     <li><span>在<span class="uicontrol">“<span>集群</span>”</span>页签，查询ClickHouse集群信息。</span><p></p>
      <ol type="a">
       <li>该页面展示已注册至<span>本产品</span>的ClickHouse集群信息。<p>相关参数说明如<a href="#clickhouse-0054__table14170211115420">表1</a>所示。</p>
        <div class="tablenoborder">
         <a name="clickhouse-0054__table14170211115420"></a><a name="table14170211115420"></a>
         <table cellpadding="4" cellspacing="0" summary="" id="clickhouse-0054__table14170211115420" frame="border" border="1" rules="all">
          <caption>
           <b>表1 </b>ClickHouse集群信息
          </caption>
          <colgroup>
           <col style="width:19.189999999999998%">
           <col style="width:80.81%">
          </colgroup>
          <thead align="left">
           <tr>
            <th align="left" class="cellrowborder" valign="top" width="19.189999999999998%" id="mcps1.3.1.2.2.2.1.1.3.2.3.1.1"><p>参数</p></th>
            <th align="left" class="cellrowborder" valign="top" width="80.81%" id="mcps1.3.1.2.2.2.1.1.3.2.3.1.2"><p>说明</p></th>
           </tr>
          </thead>
          <tbody>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.1 "><p><span>名称</span></p></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.2 "><p>ClickHouse集群名称。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.1 "><p><span>状态</span></p></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.2 "><p>ClickHouse集群的状态。</p>
             <ul>
              <li><span>在线</span>：当代理主机与ClickHouse集群所有节点连接正常时，<span class="uicontrol">“<span>状态</span>”</span>为<span class="uicontrol">“<span>在线</span>”</span>。</li>
              <li><span>离线</span>：当代理主机与ClickHouse集群所有节点连接异常时，<span class="uicontrol">“<span>状态</span>”</span>为<span class="uicontrol">“<span>离线</span>”</span>。</li>
              <li><span>异常</span>：当代理主机与ClickHouse集群部分节点连接异常时，<span class="uicontrol">“<span>状态</span>”</span>为<span class="uicontrol">“<span>异常</span>”</span>。</li>
             </ul></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.1 "><p><span>版本</span></p></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.2 "><p>ClickHouse的版本号。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.1 ">
             <div class="p">
              <span id="clickhouse-0054__zh-cn_topic_0000001792344110_text1045121611529">所属用户</span>
              <div class="note" id="clickhouse-0054__zh-cn_topic_0000001792344110_note6159153035311">
               <span class="notetitle"> 说明： </span>
               <div class="notebody">
                <p id="clickhouse-0054__zh-cn_topic_0000001792344110_p815914301534">仅1.5.0版本存在此参数。</p>
               </div>
              </div>
             </div></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.2 "><p>该主机或集群所属的数据保护管理员。</p> <p>当该主机或集群已授权给数据保护管理员时，将显示数据保护管理员的名称。如果未进行授权，则显示“--”。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.1 ">
             <div class="p">
              标签
              <div class="note" id="clickhouse-0054__zh-cn_topic_0000001792344110_note1330311543247">
               <span class="notetitle"> 说明： </span>
               <div class="notebody">
                <p id="clickhouse-0054__zh-cn_topic_0000001792344110_p630385412417">仅1.6.0及后续版本存在此参数。</p>
               </div>
              </div>
             </div></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.2 "><p>当资源已添加标签时，则此处显示标签名称，否则显示“--”。</p></td>
           </tr>
          </tbody>
         </table>
        </div></li>
       <li>单击集群名称，查看集群基本信息和与该集群相关的数据库或表集信息。</li>
      </ol> <p></p></li>
     <li><span>在<span class="uicontrol">“<span>数据库</span>”</span>页签，查询ClickHouse数据库信息。</span><p></p>
      <ol type="a">
       <li>该页面展示ClickHouse数据库的详细信息。<p>相关参数说明如<a href="#clickhouse-0054__table5610162112314">表2</a>所示。</p>
        <div class="tablenoborder">
         <a name="clickhouse-0054__table5610162112314"></a><a name="table5610162112314"></a>
         <table cellpadding="4" cellspacing="0" summary="" id="clickhouse-0054__table5610162112314" frame="border" border="1" rules="all">
          <caption>
           <b>表2 </b>ClickHouse数据库参数说明
          </caption>
          <colgroup>
           <col style="width:25.55%">
           <col style="width:74.45%">
          </colgroup>
          <thead align="left">
           <tr>
            <th align="left" class="cellrowborder" valign="top" width="25.55%" id="mcps1.3.1.2.3.2.1.1.2.2.3.1.1"><p>参数</p></th>
            <th align="left" class="cellrowborder" valign="top" width="74.45%" id="mcps1.3.1.2.3.2.1.1.2.2.3.1.2"><p>说明</p></th>
           </tr>
          </thead>
          <tbody>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.1 "><p><span>名称</span></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.2 "><p>数据库名称。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.1 "><p><span>所属集群</span></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.2 "><p>数据库所属的集群。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.1 "><p><span>SLA</span></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.2 "><p>当ClickHouse数据库已关联SLA时，则显示SLA名称，否则显示<span class="uicontrol">“--”</span>。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.1 "><p><span>SLA遵从度</span></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.2 ">
             <div class="p">
              SLA遵从度指某次备份任务是否按设定的备份频率或备份窗口成功完成备份。
              <ul id="clickhouse-0054__zh-cn_topic_0000001792344110_zh-cn_topic_0000001792344094_ul1823814519293">
               <li id="clickhouse-0054__zh-cn_topic_0000001792344110_zh-cn_topic_0000001792344094_li9238184572919">遵从：如果某次备份任务（首次全量备份除外）的备份时间满足备份窗口或备份频率要求，且备份成功，则表示SLA遵从。</li>
               <li id="clickhouse-0054__zh-cn_topic_0000001792344110_zh-cn_topic_0000001792344094_li189142052112912">不遵从：如果备份时间不满足备份窗口或备份频率要求，例如某次备份任务SLA设定的备份频率为每半小时执行一次，最终备份时间超过半小时，则表示SLA不遵从。建议调整备份频率或备份窗口。</li>
              </ul>
             </div></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.1 "><p><span><span>保护状态</span></span></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.2 "><p>ClickHouse数据库当前是否被保护。</p>
             <ul>
              <li><span>未保护</span>：ClickHouse数据库未关联SLA，或者已关联SLA但已禁用保护。</li>
              <li><span>已保护</span>：ClickHouse数据库已关联SLA，且已激活保护。</li>
              <li><span>创建中</span>：ClickHouse数据库已关联SLA，正在创建保护。</li>
             </ul></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.1 ">
             <div class="p">
              标签
              <div class="note" id="clickhouse-0054__zh-cn_topic_0000001792344110_note1330311543247_1">
               <span class="notetitle"> 说明： </span>
               <div class="notebody">
                <p id="clickhouse-0054__zh-cn_topic_0000001792344110_p630385412417_1">仅1.6.0及后续版本存在此参数。</p>
               </div>
              </div>
             </div></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.2 "><p>当资源已添加标签时，则此处显示标签名称，否则显示“--”。</p></td>
           </tr>
          </tbody>
         </table>
        </div></li>
      </ol>
      <ol type="a" start="2">
       <li>单击名称，查看总览信息、副本信息以及相关任务。
        <ul id="clickhouse-0054__zh-cn_topic_0000001792344110_ul865415431221">
         <li id="clickhouse-0054__zh-cn_topic_0000001792344110_li165311431228">总览<p id="clickhouse-0054__zh-cn_topic_0000001792344110_p18940145516325"><a name="clickhouse-0054__zh-cn_topic_0000001792344110_li165311431228"></a><a name="zh-cn_topic_0000001792344110_li165311431228"></a>显示SLA信息、任务执行时间、副本总数等。</p></li>
         <li id="clickhouse-0054__zh-cn_topic_0000001792344110_li15654174342214">副本数据<p id="clickhouse-0054__zh-cn_topic_0000001792344110_p565454392218"><a name="clickhouse-0054__zh-cn_topic_0000001792344110_li15654174342214"></a><a name="zh-cn_topic_0000001792344110_li15654174342214"></a>您可以依次按照年、月、天查找相应时间的副本。</p> <p id="clickhouse-0054__zh-cn_topic_0000001792344110_p6521122942916">时间下方显示<span><img id="clickhouse-0054__zh-cn_topic_0000001792344110_image7611125417346" src="zh-cn_image_0000001792344154.png"></span>，表示该时间存在副本。</p></li>
         <li id="clickhouse-0054__zh-cn_topic_0000001792344110_li0654134382213">相关任务<p id="clickhouse-0054__zh-cn_topic_0000001792344110_p1747754963312"><a name="clickhouse-0054__zh-cn_topic_0000001792344110_li0654134382213"></a><a name="zh-cn_topic_0000001792344110_li0654134382213"></a>展示备份、恢复等任务。</p></li>
        </ul></li>
      </ol> <p></p></li>
     <li><span>在<span class="uicontrol">“<span>表集</span>”</span>页签，查看ClickHouse表集信息。</span><p></p>
      <ol type="a">
       <li>该页面展示ClickHouse表集的详细信息。<p>相关参数说明如<a href="#clickhouse-0054__table19966163675618">表3</a>所示。</p>
        <div class="tablenoborder">
         <a name="clickhouse-0054__table19966163675618"></a><a name="table19966163675618"></a>
         <table cellpadding="4" cellspacing="0" summary="" id="clickhouse-0054__table19966163675618" frame="border" border="1" rules="all">
          <caption>
           <b>表3 </b>ClickHouse表集参数说明
          </caption>
          <colgroup>
           <col style="width:25.55%">
           <col style="width:74.45%">
          </colgroup>
          <thead align="left">
           <tr>
            <th align="left" class="cellrowborder" valign="top" width="25.55%" id="mcps1.3.1.2.4.2.1.1.2.2.3.1.1"><p>参数</p></th>
            <th align="left" class="cellrowborder" valign="top" width="74.45%" id="mcps1.3.1.2.4.2.1.1.2.2.3.1.2"><p>说明</p></th>
           </tr>
          </thead>
          <tbody>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.1 "><p><span>名称</span></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.2 "><p>ClickHouse表集名称。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.1 "><p><span>所属集群</span></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.2 "><p>ClickHouse表集所属的集群。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.1 "><p><span>所属数据库</span></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.2 "><p>ClickHouse表集所属的数据库。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.1 "><p><span>SLA</span></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.2 "><p>当ClickHouse表集已关联SLA时，则显示SLA名称，否则显示<span class="uicontrol">“--”</span>。</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.1 "><p><span>SLA遵从度</span></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.2 ">
             <div class="p">
              SLA遵从度指某次备份任务是否按设定的备份频率或备份窗口成功完成备份。
              <ul id="clickhouse-0054__zh-cn_topic_0000001792344110_zh-cn_topic_0000001792344094_ul1823814519293_1">
               <li id="clickhouse-0054__zh-cn_topic_0000001792344110_zh-cn_topic_0000001792344094_li9238184572919_1">遵从：如果某次备份任务（首次全量备份除外）的备份时间满足备份窗口或备份频率要求，且备份成功，则表示SLA遵从。</li>
               <li id="clickhouse-0054__zh-cn_topic_0000001792344110_zh-cn_topic_0000001792344094_li189142052112912_1">不遵从：如果备份时间不满足备份窗口或备份频率要求，例如某次备份任务SLA设定的备份频率为每半小时执行一次，最终备份时间超过半小时，则表示SLA不遵从。建议调整备份频率或备份窗口。</li>
              </ul>
             </div></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.1 "><p><span><span>保护状态</span></span></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.2 "><p>ClickHouse表集当前是否被保护。</p>
             <ul>
              <li><span>未保护</span>：ClickHouse表集未关联SLA，或者已关联SLA但已禁用保护。</li>
              <li><span>已保护</span>：ClickHouse表集已关联SLA，且已激活保护。</li>
              <li><span>创建中</span>：ClickHouse表集已关联SLA，正在创建保护。</li>
             </ul></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.1 ">
             <div class="p">
              标签
              <div class="note" id="clickhouse-0054__zh-cn_topic_0000001792344110_note1330311543247_2">
               <span class="notetitle"> 说明： </span>
               <div class="notebody">
                <p id="clickhouse-0054__zh-cn_topic_0000001792344110_p630385412417_2">仅1.6.0及后续版本存在此参数。</p>
               </div>
              </div>
             </div></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.2 "><p>当资源已添加标签时，则此处显示标签名称，否则显示“--”。</p></td>
           </tr>
          </tbody>
         </table>
        </div></li>
       <li>单击名称，查看总览信息、副本信息以及相关任务。
        <ul id="clickhouse-0054__zh-cn_topic_0000001792344110_ul865415431221_1">
         <li id="clickhouse-0054__zh-cn_topic_0000001792344110_li165311431228_1">总览<p id="clickhouse-0054__zh-cn_topic_0000001792344110_p18940145516325_1"><a name="clickhouse-0054__zh-cn_topic_0000001792344110_li165311431228_1"></a><a name="zh-cn_topic_0000001792344110_li165311431228_1"></a>显示SLA信息、任务执行时间、副本总数等。</p></li>
         <li id="clickhouse-0054__zh-cn_topic_0000001792344110_li15654174342214_1">副本数据<p id="clickhouse-0054__zh-cn_topic_0000001792344110_p565454392218_1"><a name="clickhouse-0054__zh-cn_topic_0000001792344110_li15654174342214_1"></a><a name="zh-cn_topic_0000001792344110_li15654174342214_1"></a>您可以依次按照年、月、天查找相应时间的副本。</p> <p id="clickhouse-0054__zh-cn_topic_0000001792344110_p6521122942916_1">时间下方显示<span><img id="clickhouse-0054__zh-cn_topic_0000001792344110_image7611125417346_1" src="zh-cn_image_0000001792344154.png"></span>，表示该时间存在副本。</p></li>
         <li id="clickhouse-0054__zh-cn_topic_0000001792344110_li0654134382213_1">相关任务<p id="clickhouse-0054__zh-cn_topic_0000001792344110_p1747754963312_1"><a name="clickhouse-0054__zh-cn_topic_0000001792344110_li0654134382213_1"></a><a name="zh-cn_topic_0000001792344110_li0654134382213_1"></a>展示备份、恢复等任务。</p></li>
        </ul></li>
      </ol> <p></p></li>
    </ol>
   </div>
  </div>
  <div>
   <div class="familylinks">
    <div class="parentlink">
     <strong>父主题：</strong> <a href="clickhouse-0053.html">ClickHouse集群环境</a>
    </div>
   </div>
  </div>
 </body>
</html>